RawMaterialComponentItem

Entity Definition

Logical Name : RawMaterialComponentItem
Physical Name : CO_COM_RAW_MTR_ITM

An associative entity that denotes an acceptable substitution for a particular RawMaterialComponent an a Recipe. Eg: BBQ Sauce is an acceptable substitute for Ketchup.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ComponentID (FK)(PK) A unique system assigned identifier for the RawMaterialComponent ID_COM Identity integer RawMaterialComponent(CO_COM_RAW_MTR)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) Item(AS_ITM)

Relationships

Parent Entity Verb Phrase Child Entity
RawMaterialComponent may be substituted with RawMaterialComponentItem
Item may substitute for RawMaterialComponentItem

Logical Views containing RawMaterialComponentItem

Logical View
Logical 01030 - Item Description - Recipe View